package com.koron.css2.newProjectCenter.function.mapper;

import com.koron.css2.newProjectCenter.function.bean.AccessoryLogBean;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface AccessoryLogMapper {
    @Insert("insert into pub_accessory_log" +
            "(id, filename, original_file_name, my_current_node_id, flow_sn, url, create_time, create_account, create_name, update_time, update_account, update_name) value " +
            "(#{id}, #{filename}, #{originalFilename}, #{myCurrentNodeId}, #{flowSn}, #{url}, #{createTime} , #{createAccount} , #{createName} ,#{updateTime} , #{updateAccount} , #{updateName})")
    void insert(AccessoryLogBean bean);

    @Select("select * from pub_accessory_log where is_deleted = false order by create_time desc ")
    List<AccessoryLogBean> selectAll();
}
